Data Analysis on Top 1000 Movies by IMDB Rating

By: Suraj Honkamble

Import required libraries

Load the dataset

Column Information

Missing values

Data Cleaning

Convert Release_Year to Int so that we can perform some time series analysis.

There is one entry in released year column "PG" lets see what is is.

From internet i found that "Apollo 13" movie released in year 2019, replace "PG" with "2019"

Convert Runtime column to numeric type

Filling the missing values in Certificate column

Source : https://www.imdb.com/ From this source i found that the ratings for these movies are mising, here the Content Rating is "Unrated". So it is better to impute the missing Certificate for Content Rating as Unrated.

Filling missing values in Meta Score column

Meta score is from 0 to 100 so this is a descrete contineous column so Fill the missing values which Mode of this column.

Convert Meta Score to numerical type

Fill missing values in Gross columns

FIlling missing values with 0 and then converting the column to numeric and then check the outliers and then decide which statistic value is best fit to fill the missing values.

Check for outliers

Many outliers in this columns so it is better to fill the missing value(Now the value is 0) with median.

Convert Gross into Million scale

Cleaned Data

Exploratory Data Analysis

Univariate analysis

Analyze Series_Title

One is Original that is Telugu version and other one is copied Hindi version.

Analyze Resease Year

In which calender year most of high IMDB rated movies are released?

In which calender year lest of high IMDB rated movies are released?

Count of most rated IMDB movies by Year

From Graph we can clearly see that in year 1923 and 1929 no high rated movie is released.

Analyze Certificate or Content Rating column.

Which Content Type(Certificate) has most high rated movies.

  1. U-Unrestricted Content type has most top rated movies.
  2. TV-14,16,TV-MA and U/A has least top rated movies.

Analyze Runtime

What is logest, shortest and average movie duration for top rated movies?

Distribution of Runtime or Movie Duration

  1. Most of the top rated movies have run-time duration between 100 to 150 minutes.
  2. Longest run-time duration is 321 minutes, Shortest run-time duration is 45 minutes and Average run-time duration is 122 minutes.

Analyze Genre

Top 5 Genres with highest number of high rated movies.

Drama Genre Category has more top rated movies.

Analyze IMDB rating

Most of the High rated movies got IMDb rating between 7.6 to 8.1.

Analyze Metascore

Higher the Meta Score better is the movie revie.

Most of the high rated movies got Meta Score 76 from well known critics.

Analyze Number of Votes

Right skewd data.

Analyze Gross

  1. Most of to rated movies has Gross Net between 1000 $ to 200M $
  2. Highest Grossing top rated movie has 936M $ Gross net.

Aalyze Director column

Which director gave most top rated movies

Alfred Hitchcock directed totaly 14 top rated movie. Steven Spielberg directed 13 top rated movies.

Analyze Star/Casts column

There 4 top Stars in each movie. Lets create a seperate dataframe to check the actor who working in many top rated movies.

Bivariate and Multivariate analaysis.

Name the top 10 longest duration movie?

The logest Duration movie is Gangs of Wasseypur which a hindi movie with duration 330 minutes.

Name the top 10 least duration movie?

Shortest duration moview is Sherlock Jr with Runtime 45 minutes.

What is the average runtime by each year?

From Graph, the average runtime is almost constant from 60's to 2020.

What is the average IMDB rating by each year?

Name the Movies with high IMDB rating?

The Shawshank Redemption is the highest rated movie with IMDB rating 9.3.

Name the Movies with high Meta score?

The Godfather, Notorious, Boyhood, Casablanca and Fanny oach Alexander. are the top 5 Movies with High Meta Score.

Which Movie recieved highest Votes.

The Shawshank Redemption, The Dark Knights, Inception, Fight Club and Pulp Fiction movies received most votes.

Name the Top 10 Highesr Grossing Movies

Relationship between Runtime and IMDB Rating

From above Scatter, look like there is no relation between the IMDB rating and the Movie Duration.

Is there any relation between Released Year, Runtime, IMDB Rating, Meta Score, Votes and Gross?

There is high co=relation between Votes and IMDB Rating, and Gross and Votes.

Relationship between Votes and IMDB Rating

There is a positive correlation between number of votes and IMDB rating, as the Number of votes increases the IMDB Rating increases.

Relationship between IMDB rating and Gross.

Top 10 Genre with high Average Run time

High Average Runtime movies belongs to Adventure, Drama, Musical Genre.

Top 10 Genre with least Average Run time

Comedy, Musical, War type genre has least average runtime.

Top 10 Genres with high Average IMDB Rating

The Animation, Drama, War Genre type movies has highest average rating.

Top 10 Genres with least Average IMDB Rating

Top 10 Genres with high Average Meta Score

Mystery, Romance, Thriller Genre type movies has 100 Metascore.

Top 10 Genres with high Average Votes recieved.

Action, Sci-FI Genre tye movies got nearly 1.2M average Votes.

Top 10 Genres by highest average Gross Net

Family, Sci-Fi Genre type movies has highest average Gross Net about 435M Dollar. This is expected because some movie earns huge amount worldwide while some earns less.

Top Content Type(Certificate) by average Number of Votes

U/A Content or Certifcate type category has highest average VOtes.

Top Content Type(Certificate) by average Grossing

Name the top 10 Director with highest average IMDB Rating

Frank Darabont is the most successful director.

Top 10 Director with high Gross collection

Steven Spielberg's Directed Movies Collected 2.478B $ Worldwide

Name the top 5 Director and Stars who worked in high Grossing Movies.

Summary/Conclusion

  1. In the Year of 2014 most high IMDB Rated movies are Released.
  2. U-Unrestricted Content type has most top IMDB rated movies. TV-14,16,TV-MA and U/A has least IMDB rated movies.
  3. Most of the top rated movies have run-time duration between 100 to 150 minutes. Longest run-time duration is 321 minutes, Shortest run-time duration is 45 minutes and Average run-time duration is 122 minutes.
  4. The logest Duration movie is Gangs of Wasseypur which a hindi movie with duration 330 minutes. Shortest duration moview is Sherlock Jr with Runtime 45 minutes.
  5. The Shawshank Redemption is the highest rated movie with IMDB rating 9.3.
  6. The Godfather, Notorious, Boyhood, Casablanca and Fanny oach Alexander. are the top 5 Movies with High Meta Score.
  7. The Shawshank Redemption, The Dark Knights, Inception, Fight Club and Pulp Fiction movies received most votes.
  8. High Average Runtime movies belongs to Adventure, Drama, Musical Genre.
  9. The Animation, Drama, War Genre type movies has highest average rating.
  10. Mystery, Romance, Thriller Genre type movies has 100 Metascore.
  11. Action, Sci-FI Genre tye movies got nearly 1.2M average Votes.
  12. Family, Sci-Fi Genre type movies has highest average Gross Net about 435M Dollar. This is expected because some movie earns huge amount worldwide while some earns less.
  13. U/A Content or Certifcate type category has highest average VOtes.
  14. Alfred Hitchcock directed totaly 14 top rated movie. Steven Spielberg directed 13 top rated movies.
  15. Frank Darabont is the most successful director with average IMDB rating of 8.95.
  16. Gross Collection of Steven Spielberg's Directed Movies is above 2.478B $ Worldwide